package com.bcu.calculus.mapper;

import com.bcu.calculus.entity.Total;
import io.swagger.models.auth.In;

import java.util.HashMap;
import java.util.List;

public interface TotalMapper {
    int deleteByPrimaryKey(String totalScoreId);

    int insert(Total record);

    int insertSelective(Total record);

    Total selectByPrimaryKey(String totalScoreId);

    int updateByPrimaryKeySelective(Total record);

    int updateByPrimaryKey(Total record);

    List<Total> selectAll();

    Total selectOneByUserId(String userId,Integer semId);

    Double totalAvg(Integer totalSemId);

    Double totalPRate(Integer totalSemId);

    List totalcount1(Integer totalSemId);

    List totalcount2(Integer totalSemId);

    List totalcount3(Integer totalSemId);

    List totalcount4(Integer totalSemId);

    List totalcount5(Integer totalSemId);

    List totalBranch(Integer totalSemId);

    List totalAvgBranch(Integer totalSemId);

    List totalPRateBranch(Integer totalSemId);

    List totalMaxBranch(Integer totalSemId);

    List count(Integer totalSemId);

    Integer count1(Integer totalSemId);

    Integer count2(Integer totalSemId);

    Integer count3(Integer totalSemId);

    Integer count4(Integer totalSemId);

    Integer count5(Integer totalSemId);

    List getAllRank(Integer totalSemId);

    List getAllBranchRank(Integer userBranch, Integer totalSemId);

    List<Total> findAllUserAndInfo(Integer totalSemId);

    List getTotalScore(String totalUserId, Integer totalSemId);
}